CREATE procedure [dbo].[BAEEventAddGuest] @GuestID int,
      @RegistrantID varchar(300),
      @EventCode varchar(50),
      @GuestBadge varchar(50),
      @FirstName varchar(50),
      @MiddleInitial varchar(50),
      @LastName varchar(50),
      @Address varchar(50),
      @Address2 varchar(50),
      @Address3 varchar(50),
      @City varchar(64),
      @State varchar(48),
      @PostalCode varchar(50),
      @Country varchar(25),
      @cartEventFuncID int,
      @Prefix varchar(25),
      @Suffix varchar(10),
      @Nickname varchar(20),  
      @Designation varchar(20),
      @MyTitle varchar(50),
      @Company varchar(80) as

DECLARE @CartEventID int, @Quantity int, @Title varchar(512), @Description varchar(2048), @FunctionStart datetime, @FunctionEnd datetime, @Price money

      -- Get the CartEventID
      SELECT @CartEventID = CartEventID
      FROM CartEvent
      WHERE RegistrantID = @RegistrantID AND EventCode = @EventCode

      SELECT EventGuestID
      FROM EventGuest
      WHERE EventGuestID = @GuestID

      --If rowcount > 0, then guest IS already in the system
      IF @@ROWCOUNT > 0
      begin
            UPDATE EventGuest
                  SET GuestBadge = @GuestBadge,
                  FirstName = @FirstName,
                  MiddleInitial = @MiddleInitial,
                  LastName = @LastName,
                  Address1 = @Address,
                  Address2 = @Address2,
                  Address3 = @Address3,
                  City = @City,
                  StateProvince = @State,
                  PostalCode = @PostalCode,
                  Country = @Country,
                  CartEventFunctionID = @cartEventFuncID,
                  Prefix = @Prefix,
                  Suffix = @Suffix,
                  Nickname = @Nickname,  
                  Designation = @Designation,
                  Title = @MyTitle,
                  Company = @Company
            WHERE EventGuestID = @GuestID;

            SELECT * FROM EventGuest WHERE EventGuestID = @GuestID;
      end   

       --If rowcount = 0, then guest IS NOT IN the system
      IF @@ROWCOUNT = 0
      begin
            -- INSERT the guest info INTO the temp table
            INSERT INTO EventGuest(RegistrantID, EventCode, GuestBadge, FirstName, MiddleInitial, LastName, Address1, Address2, Address3, City, StateProvince, PostalCode, Country, CartEventFunctionID, Prefix, Suffix, Nickname, Designation, Title, Company)
            VALUES(@RegistrantID, @EventCode, @GuestBadge, @FirstName, @MiddleInitial, @LastName, @Address, @Address2, @Address3, @City, @State, @PostalCode, @Country, @cartEventFuncID, @Prefix, @Suffix, @Nickname, @Designation, @MyTitle, @Company)

            SELECT CAST(@@IDENTITY AS INT);
      end

GO